Pandas Profiling Report

Dataset statistics

Number of variables	18
Number of observations	36008
Missing cells	94400
Missing cells (%)	14.6%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	4.9 MiB
Average record size in memory	144.0 B

Variable types

Numeric	11
Text	3
Unsupported	2
Categorical	1
DateTime	1

Alerts

`latitude` is highly overall correlated with `longitude`	High correlation
`longitude` is highly overall correlated with `latitude`	High correlation
`number_of_reviews` is highly overall correlated with `number_of_reviews_ltm` and 1 other fields	High correlation
`number_of_reviews_ltm` is highly overall correlated with `number_of_reviews` and 1 other fields	High correlation
`reviews_per_month` is highly overall correlated with `number_of_reviews` and 1 other fields	High correlation
`room_type` is highly imbalanced (58.4%)	Imbalance
`neighbourhood_group` has 36008 (100.0%) missing values	Missing
`price` has 1771 (4.9%) missing values	Missing
`last_review` has 10302 (28.6%) missing values	Missing
`reviews_per_month` has 10302 (28.6%) missing values	Missing
`license` has 36008 (100.0%) missing values	Missing
`price` is highly skewed (γ1 = 66.96707573)	Skewed
`minimum_nights` is highly skewed (γ1 = 28.22092657)	Skewed
`id` has unique values	Unique
`neighbourhood_group` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`license` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`number_of_reviews` has 10302 (28.6%) zeros	Zeros
`availability_365` has 5475 (15.2%) zeros	Zeros
`number_of_reviews_ltm` has 14214 (39.5%) zeros	Zeros

Reproduction

Analysis started	2024-04-25 21:05:27.420478
Analysis finished	2024-04-25 21:07:23.434123
Duration	1 minute and 56.01 seconds
Software version	ydata-profiling vv4.7.0
Download configuration	config.json

id
Real number (ℝ)

UNIQUE

Distinct	36008
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.4457301 × 10¹⁷

Minimum	17878
Maximum	1.0538233 × 10¹⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	281.4 KiB

Quantile statistics

Minimum	17878
5-th percentile	2958870.7
Q1	28637937
median	5.7613679 × 10¹⁷
Q3	8.7267609 × 10¹⁷
95-th percentile	1.0398874 × 10¹⁸
Maximum	1.0538233 × 10¹⁸
Range	1.0538233 × 10¹⁸
Interquartile range (IQR)	8.7267609 × 10¹⁷

Descriptive statistics

Standard deviation	4.4185817 × 10¹⁷
Coefficient of variation (CV)	0.99389336
Kurtosis	-1.8169913
Mean	4.4457301 × 10¹⁷
Median Absolute Deviation (MAD)	4.7330968 × 10¹⁷
Skewness	0.089169612
Sum	-3.5887837 × 10¹⁸
Variance	1.9523864 × 10³⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17878	1	< 0.1%
7.963583977 × 10¹⁷	1	< 0.1%
7.971095024 × 10¹⁷	1	< 0.1%
7.971143587 × 10¹⁷	1	< 0.1%
7.971144518 × 10¹⁷	1	< 0.1%
7.971145873 × 10¹⁷	1	< 0.1%
7.935195318 × 10¹⁷	1	< 0.1%
7.935705612 × 10¹⁷	1	< 0.1%
7.963588726 × 10¹⁷	1	< 0.1%
7.970988872 × 10¹⁷	1	< 0.1%
Other values (35998)	35998	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
17878	1	< 0.1%
25026	1	< 0.1%
35764	1	< 0.1%
41198	1	< 0.1%
48305	1	< 0.1%
48901	1	< 0.1%
49179	1	< 0.1%
50759	1	< 0.1%
51703	1	< 0.1%
53533	1	< 0.1%

Value	Count	Frequency (%)
1.053823262 × 10¹⁸	1	< 0.1%
1.053808194 × 10¹⁸	1	< 0.1%
1.05378934 × 10¹⁸	1	< 0.1%
1.053756202 × 10¹⁸	1	< 0.1%
1.053746406 × 10¹⁸	1	< 0.1%
1.053743193 × 10¹⁸	1	< 0.1%
1.053736264 × 10¹⁸	1	< 0.1%
1.053720091 × 10¹⁸	1	< 0.1%
1.053716797 × 10¹⁸	1	< 0.1%
1.053711356 × 10¹⁸	1	< 0.1%

name
Text

Distinct	14150
Distinct (%)	39.3%
Missing	0
Missing (%)	0.0%
Memory size	281.4 KiB

Length

Max length	168
Median length	93
Mean length	63.446845
Min length	31

Characters and Unicode

Total characters	2284594
Distinct characters	93
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	10847 ?
Unique (%)	30.1%

Sample

1st row	Condo in Rio de Janeiro · ★4.70 · 2 bedrooms · 2 beds · 1 bath
2nd row	Rental unit in Rio de Janeiro · 1 bedroom · 1 bed · 1 bath
3rd row	Condo in Rio de Janeiro · ★4.57 · 1 bedroom · 1 bed · 1 bath
4th row	Rental unit in Rio de Janeiro · ★4.72 · 1 bedroom · 1 bed · 1 bath
5th row	Rental unit in Rio de Janeiro · ★4.81 · 2 bedrooms · 3 beds · 2 baths

Value	Count	Frequency (%)
·	132069	23.3%
1	52893	9.4%
in	36008	6.4%
2	27550	4.9%
unit	26976	4.8%
rental	26976	4.8%
rio	25052	4.4%
de	24336	4.3%
janeiro	24223	4.3%
beds	23303	4.1%
Other values (494)	166266	29.4%

Most occurring characters

Value	Count	Frequency (%)
	529873	23.2%
e	170589	7.5%
o	138339	6.1%
·	132069	5.8%
n	126164	5.5%
a	125079	5.5%
i	120678	5.3%
b	110655	4.8%
d	105714	4.6%
t	100258	4.4%
Other values (83)	625176	27.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2284594	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	529873	23.2%
e	170589	7.5%
o	138339	6.1%
·	132069	5.8%
n	126164	5.5%
a	125079	5.5%
i	120678	5.3%
b	110655	4.8%
d	105714	4.6%
t	100258	4.4%
Other values (83)	625176	27.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2284594	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	529873	23.2%
e	170589	7.5%
o	138339	6.1%
·	132069	5.8%
n	126164	5.5%
a	125079	5.5%
i	120678	5.3%
b	110655	4.8%
d	105714	4.6%
t	100258	4.4%
Other values (83)	625176	27.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2284594	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	529873	23.2%
e	170589	7.5%
o	138339	6.1%
·	132069	5.8%
n	126164	5.5%
a	125079	5.5%
i	120678	5.3%
b	110655	4.8%
d	105714	4.6%
t	100258	4.4%
Other values (83)	625176	27.4%

host_id
Real number (ℝ)

Distinct	21980
Distinct (%)	61.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.784179 × 10⁸

Minimum	1671
Maximum	5.5271448 × 10⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	281.4 KiB

Quantile statistics

Minimum	1671
5-th percentile	2981903.8
Q1	24167859
median	96445730
Q3	3.2560925 × 10⁸
95-th percentile	5.0692743 × 10⁸
Maximum	5.5271448 × 10⁸
Range	5.5271281 × 10⁸
Interquartile range (IQR)	3.0144139 × 10⁸

Descriptive statistics

Standard deviation	1.7696843 × 10⁸
Coefficient of variation (CV)	0.99187597
Kurtosis	-0.90013792
Mean	1.784179 × 10⁸
Median Absolute Deviation (MAD)	86663858
Skewness	0.75158178
Sum	6.4244719 × 10¹²
Variance	3.1317825 × 10¹⁶
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6000862	185	0.5%
91654021	157	0.4%
341887136	145	0.4%
1982737	142	0.4%
47584281	142	0.4%
371026651	128	0.4%
14315601	85	0.2%
74463624	80	0.2%
30165706	77	0.2%
12909867	69	0.2%
Other values (21970)	34798	96.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1671	1	< 0.1%
3607	1	< 0.1%
11739	9	< 0.1%
19065	3	< 0.1%
34105	2	< 0.1%
37072	1	< 0.1%
48024	7	< 0.1%
60098	1	< 0.1%
64036	2	< 0.1%
68997	1	< 0.1%

Value	Count	Frequency (%)
552714482	1	< 0.1%
552420950	1	< 0.1%
552339316	1	< 0.1%
552326533	1	< 0.1%
552283430	1	< 0.1%
552282629	1	< 0.1%
552267363	1	< 0.1%
552264669	1	< 0.1%
552258899	1	< 0.1%
552258099	1	< 0.1%

host_name
Text

Distinct	6268
Distinct (%)	17.4%
Missing	9
Missing (%)	< 0.1%
Memory size	281.4 KiB

Length

Max length	34
Median length	32
Mean length	7.3657602
Min length	1

Characters and Unicode

Total characters	265160
Distinct characters	105
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3526 ?
Unique (%)	9.8%

Sample

1st row	Matthias
2nd row	Zeilma , Da
3rd row	Bob
4th row	Viviane
5th row	Maria José

Value	Count	Frequency (%)
maria	894	2.1%
ana	581	1.3%
rio	516	1.2%
carlos	493	1.1%
luiz	382	0.9%
daniel	359	0.8%
rodrigo	336	0.8%
ricardo	332	0.8%
pedro	331	0.8%
paulo	319	0.7%
Other values (5070)	38787	89.5%

Most occurring characters

Value	Count	Frequency (%)
a	40312	15.2%
i	24676	9.3%
e	21035	7.9%
r	18618	7.0%
o	18004	6.8%
n	17664	6.7%
l	14927	5.6%
s	9166	3.5%
u	7752	2.9%
d	7368	2.8%
Other values (95)	85638	32.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	265160	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	40312	15.2%
i	24676	9.3%
e	21035	7.9%
r	18618	7.0%
o	18004	6.8%
n	17664	6.7%
l	14927	5.6%
s	9166	3.5%
u	7752	2.9%
d	7368	2.8%
Other values (95)	85638	32.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	265160	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	40312	15.2%
i	24676	9.3%
e	21035	7.9%
r	18618	7.0%
o	18004	6.8%
n	17664	6.7%
l	14927	5.6%
s	9166	3.5%
u	7752	2.9%
d	7368	2.8%
Other values (95)	85638	32.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	265160	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	40312	15.2%
i	24676	9.3%
e	21035	7.9%
r	18618	7.0%
o	18004	6.8%
n	17664	6.7%
l	14927	5.6%
s	9166	3.5%
u	7752	2.9%
d	7368	2.8%
Other values (95)	85638	32.3%

neighbourhood_group
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	36008
Missing (%)	100.0%
Memory size	281.4 KiB

neighbourhood
Text

Distinct	156
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	281.4 KiB

Length

Max length	24
Median length	22
Mean length	10.281743
Min length	3

Characters and Unicode

Total characters	370225
Distinct characters	60
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	10 ?
Unique (%)	< 0.1%

Sample

1st row	Copacabana
2nd row	Flamengo
3rd row	Copacabana
4th row	Copacabana
5th row	Copacabana

Value	Count	Frequency (%)
copacabana	10982	21.7%
tijuca	3953	7.8%
barra	3653	7.2%
da	3639	7.2%
ipanema	3455	6.8%
jacarepaguá	1813	3.6%
recreio	1804	3.6%
dos	1804	3.6%
bandeirantes	1804	3.6%
leblon	1742	3.4%
Other values (186)	16035	31.6%

Most occurring characters

Value	Count	Frequency (%)
a	91184	24.6%
o	27519	7.4%
n	25976	7.0%
e	24028	6.5%
r	20318	5.5%
c	19773	5.3%
p	16524	4.5%
	14676	4.0%
C	14193	3.8%
b	13340	3.6%
Other values (50)	102694	27.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	370225	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	91184	24.6%
o	27519	7.4%
n	25976	7.0%
e	24028	6.5%
r	20318	5.5%
c	19773	5.3%
p	16524	4.5%
	14676	4.0%
C	14193	3.8%
b	13340	3.6%
Other values (50)	102694	27.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	370225	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	91184	24.6%
o	27519	7.4%
n	25976	7.0%
e	24028	6.5%
r	20318	5.5%
c	19773	5.3%
p	16524	4.5%
	14676	4.0%
C	14193	3.8%
b	13340	3.6%
Other values (50)	102694	27.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	370225	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	91184	24.6%
o	27519	7.4%
n	25976	7.0%
e	24028	6.5%
r	20318	5.5%
c	19773	5.3%
p	16524	4.5%
	14676	4.0%
C	14193	3.8%
b	13340	3.6%
Other values (50)	102694	27.7%

latitude
Real number (ℝ)

HIGH CORRELATION

Distinct	20707
Distinct (%)	57.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-22.96758

Minimum	-23.073276
Maximum	-22.74969
Zeros	0
Zeros (%)	0.0%
Negative	36008
Negative (%)	100.0%
Memory size	281.4 KiB

Quantile statistics

Minimum	-23.073276
5-th percentile	-23.014033
Q1	-22.984712
median	-22.97286
Q3	-22.956277
95-th percentile	-22.910943
Maximum	-22.74969
Range	0.32358596
Interquartile range (IQR)	0.0284346

Descriptive statistics

Standard deviation	0.034686656
Coefficient of variation (CV)	-0.0015102443
Kurtosis	4.1290956
Mean	-22.96758
Median Absolute Deviation (MAD)	0.01227
Skewness	1.2785007
Sum	-827016.63
Variance	0.0012031641
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-22.9980396	53	0.1%
-22.9808971	35	0.1%
-22.9804488	25	0.1%
-22.98456	20	0.1%
-22.98353	16	< 0.1%
-22.98463	16	< 0.1%
-22.98347	16	< 0.1%
-22.9792207	16	< 0.1%
-22.98431	16	< 0.1%
-22.98346	16	< 0.1%
Other values (20697)	35779	99.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-23.07327596	1	< 0.1%
-23.07305	1	< 0.1%
-23.07284	1	< 0.1%
-23.07273666	1	< 0.1%
-23.07262	1	< 0.1%
-23.07241	1	< 0.1%
-23.0722	2	< 0.1%
-23.07215409	1	< 0.1%
-23.07215	1	< 0.1%
-23.07211	1	< 0.1%

Value	Count	Frequency (%)
-22.74969	1	< 0.1%
-22.74995	1	< 0.1%
-22.75051	1	< 0.1%
-22.75061	1	< 0.1%
-22.75069162	1	< 0.1%
-22.75077	1	< 0.1%
-22.75094	1	< 0.1%
-22.75144	1	< 0.1%
-22.75195	1	< 0.1%
-22.75239	1	< 0.1%

longitude
Real number (ℝ)

HIGH CORRELATION

Distinct	22606
Distinct (%)	62.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-43.249377

Minimum	-43.723009
Maximum	-43.1044
Zeros	0
Zeros (%)	0.0%
Negative	36008
Negative (%)	100.0%
Memory size	281.4 KiB

Quantile statistics

Minimum	-43.723009
5-th percentile	-43.471277
Q1	-43.306566
median	-43.194825
Q3	-43.185573
95-th percentile	-43.174845
Maximum	-43.1044
Range	0.61860934
Interquartile range (IQR)	0.12099287

Descriptive statistics

Standard deviation	0.099240936
Coefficient of variation (CV)	-0.0022946212
Kurtosis	1.2008505
Mean	-43.249377
Median Absolute Deviation (MAD)	0.017098252
Skewness	-1.4714596
Sum	-1557323.5
Variance	0.0098487634
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-43.2568208	53	0.1%
-43.4224405	35	0.1%
-43.4226697	25	0.1%
-43.19053	19	0.1%
-43.1911	18	< 0.1%
-43.19043	17	< 0.1%
-43.19024	17	< 0.1%
-43.1907952	16	< 0.1%
-43.4731697	16	< 0.1%
-43.19002	15	< 0.1%
Other values (22596)	35777	99.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-43.72300934	1	< 0.1%
-43.71038	1	< 0.1%
-43.70128586	1	< 0.1%
-43.7012179	1	< 0.1%
-43.70074	1	< 0.1%
-43.6998188	1	< 0.1%
-43.6991893	1	< 0.1%
-43.69332	1	< 0.1%
-43.69155	1	< 0.1%
-43.69005613	1	< 0.1%

Value	Count	Frequency (%)
-43.1044	1	< 0.1%
-43.10460541	1	< 0.1%
-43.10505	1	< 0.1%
-43.10513196	1	< 0.1%
-43.10552	1	< 0.1%
-43.10575	1	< 0.1%
-43.105767	1	< 0.1%
-43.10579556	1	< 0.1%
-43.10593	1	< 0.1%
-43.10605	1	< 0.1%

room_type
Categorical

IMBALANCE

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	281.4 KiB

Entire home/apt	28468
Private room	6910
Shared room	592
Hotel room	38

Length

Max length	15
Median length	15
Mean length	14.353255
Min length	10

Characters and Unicode

Total characters	516832
Distinct characters	19
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Entire home/apt
2nd row	Private room
3rd row	Entire home/apt
4th row	Entire home/apt
5th row	Entire home/apt

Common Values

Value	Count	Frequency (%)
Entire home/apt	28468	79.1%
Private room	6910	19.2%
Shared room	592	1.6%
Hotel room	38	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
entire	28468	39.5%
home/apt	28468	39.5%
room	7540	10.5%
private	6910	9.6%
shared	592	0.8%
hotel	38	0.1%

Most occurring characters

Value	Count	Frequency (%)
e	64476	12.5%
t	63884	12.4%
o	43586	8.4%
r	43510	8.4%
m	36008	7.0%
	36008	7.0%
a	35970	7.0%
i	35378	6.8%
h	29060	5.6%
p	28468	5.5%
Other values (9)	100484	19.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	516832	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	64476	12.5%
t	63884	12.4%
o	43586	8.4%
r	43510	8.4%
m	36008	7.0%
	36008	7.0%
a	35970	7.0%
i	35378	6.8%
h	29060	5.6%
p	28468	5.5%
Other values (9)	100484	19.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	516832	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	64476	12.5%
t	63884	12.4%
o	43586	8.4%
r	43510	8.4%
m	36008	7.0%
	36008	7.0%
a	35970	7.0%
i	35378	6.8%
h	29060	5.6%
p	28468	5.5%
Other values (9)	100484	19.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	516832	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	64476	12.5%
t	63884	12.4%
o	43586	8.4%
r	43510	8.4%
m	36008	7.0%
	36008	7.0%
a	35970	7.0%
i	35378	6.8%
h	29060	5.6%
p	28468	5.5%
Other values (9)	100484	19.4%

price
Real number (ℝ)

MISSING SKEWED

Distinct	3230
Distinct (%)	9.4%
Missing	1771
Missing (%)	4.9%
Infinite	0
Infinite (%)	0.0%
Mean	1211.7196

Minimum	0
Maximum	552637
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	281.4 KiB

Quantile statistics

Minimum	0
5-th percentile	150
Q1	361
median	660
Q3	1114
95-th percentile	3135.4
Maximum	552637
Range	552637
Interquartile range (IQR)	753

Descriptive statistics

Standard deviation	5790.9374
Coefficient of variation (CV)	4.7791069
Kurtosis	5727.864
Mean	1211.7196
Median Absolute Deviation (MAD)	340
Skewness	66.967076
Sum	41485643
Variance	33534956
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1000	538	1.5%
500	498	1.4%
300	398	1.1%
800	389	1.1%
600	382	1.1%
400	374	1.0%
350	328	0.9%
1500	321	0.9%
200	311	0.9%
250	304	0.8%
Other values (3220)	30394	84.4%
(Missing)	1771	4.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
26	3	< 0.1%
30	1	< 0.1%
33	1	< 0.1%
35	1	< 0.1%
39	1	< 0.1%
40	2	< 0.1%
41	1	< 0.1%
42	2	< 0.1%
43	2	< 0.1%

Value	Count	Frequency (%)
552637	1	< 0.1%
500000	2	< 0.1%
214786	1	< 0.1%
189982	1	< 0.1%
110130	1	< 0.1%
100118	1	< 0.1%
100000	5	< 0.1%
99000	1	< 0.1%
80080	1	< 0.1%
69157	1	< 0.1%

minimum_nights
Real number (ℝ)

SKEWED

Distinct	71
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.4193513

Minimum	1
Maximum	1125
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	281.4 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	2
Q3	3
95-th percentile	7
Maximum	1125
Range	1124
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	22.738877
Coefficient of variation (CV)	5.1452974
Kurtosis	1033.295
Mean	4.4193513
Median Absolute Deviation (MAD)	1
Skewness	28.220927
Sum	159132
Variance	517.05651
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	10443	29.0%
1	9243	25.7%
3	7858	21.8%
4	2883	8.0%
5	2446	6.8%
7	1011	2.8%
10	422	1.2%
6	374	1.0%
30	301	0.8%
15	286	0.8%
Other values (61)	741	2.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	9243	25.7%
2	10443	29.0%
3	7858	21.8%
4	2883	8.0%
5	2446	6.8%
6	374	1.0%
7	1011	2.8%
8	57	0.2%
9	14	< 0.1%
10	422	1.2%

Value	Count	Frequency (%)
1125	1	< 0.1%
1000	3	< 0.1%
999	3	< 0.1%
960	1	< 0.1%
730	1	< 0.1%
720	1	< 0.1%
630	1	< 0.1%
500	3	< 0.1%
365	38	0.1%
362	1	< 0.1%

number_of_reviews
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	367
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	19.545545

Minimum	0
Maximum	638
Zeros	10302
Zeros (%)	28.6%
Negative	0
Negative (%)	0.0%
Memory size	281.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	4
Q3	20
95-th percentile	93
Maximum	638
Range	638
Interquartile range (IQR)	20

Descriptive statistics

Standard deviation	40.60038
Coefficient of variation (CV)	2.0772191
Kurtosis	29.974078
Mean	19.545545
Median Absolute Deviation (MAD)	4
Skewness	4.4850733
Sum	703796
Variance	1648.3908
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	10302	28.6%
1	3233	9.0%
2	2282	6.3%
3	1641	4.6%
4	1308	3.6%
5	1103	3.1%
6	870	2.4%
7	803	2.2%
8	658	1.8%
9	641	1.8%
Other values (357)	13167	36.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	10302	28.6%
1	3233	9.0%
2	2282	6.3%
3	1641	4.6%
4	1308	3.6%
5	1103	3.1%
6	870	2.4%
7	803	2.2%
8	658	1.8%
9	641	1.8%

Value	Count	Frequency (%)
638	1	< 0.1%
627	1	< 0.1%
587	1	< 0.1%
555	1	< 0.1%
552	1	< 0.1%
537	1	< 0.1%
532	1	< 0.1%
504	1	< 0.1%
500	1	< 0.1%
484	1	< 0.1%

last_review
Date

MISSING

Distinct	1424
Distinct (%)	5.5%
Missing	10302
Missing (%)	28.6%
Memory size	281.4 KiB

Minimum	2012-02-21 00:00:00
Maximum	2023-12-29 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

reviews_per_month
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	678
Distinct (%)	2.6%
Missing	10302
Missing (%)	28.6%
Infinite	0
Infinite (%)	0.0%
Mean	1.0462771

Minimum	0.01
Maximum	13.75
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	281.4 KiB

Quantile statistics

Minimum	0.01
5-th percentile	0.04
Q1	0.2
median	0.67
Q3	1.5
95-th percentile	3.33
Maximum	13.75
Range	13.74
Interquartile range (IQR)	1.3

Descriptive statistics

Standard deviation	1.1578162
Coefficient of variation (CV)	1.1066056
Kurtosis	8.2957752
Mean	1.0462771
Median Absolute Deviation (MAD)	0.53
Skewness	2.215832
Sum	26895.6
Variance	1.3405383
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.1	623	1.7%
0.06	563	1.6%
0.08	494	1.4%
0.19	481	1.3%
0.04	453	1.3%
0.02	440	1.2%
0.13	396	1.1%
0.25	370	1.0%
1	354	1.0%
0.17	331	0.9%
Other values (668)	21201	58.9%
(Missing)	10302	28.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.01	234	0.6%
0.02	440	1.2%
0.03	296	0.8%
0.04	453	1.3%
0.05	205	0.6%
0.06	563	1.6%
0.07	253	0.7%
0.08	494	1.4%
0.09	254	0.7%
0.1	623	1.7%

Value	Count	Frequency (%)
13.75	2	< 0.1%
13.52	1	< 0.1%
11.6	1	< 0.1%
11.41	1	< 0.1%
11.32	1	< 0.1%
11.25	1	< 0.1%
11.03	1	< 0.1%
10.54	1	< 0.1%
10.32	1	< 0.1%
10	1	< 0.1%

calculated_host_listings_count
Real number (ℝ)

Distinct	58
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.4932237

Minimum	1
Maximum	185
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	281.4 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	2
Q3	5
95-th percentile	43
Maximum	185
Range	184
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	25.677082
Coefficient of variation (CV)	2.70478
Kurtosis	23.911237
Mean	9.4932237
Median Absolute Deviation (MAD)	1
Skewness	4.7436407
Sum	341832
Variance	659.31253
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	17249	47.9%
2	5372	14.9%
3	2535	7.0%
4	1624	4.5%
5	1000	2.8%
6	924	2.6%
7	581	1.6%
8	504	1.4%
9	432	1.2%
12	372	1.0%
Other values (48)	5415	15.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	17249	47.9%
2	5372	14.9%
3	2535	7.0%
4	1624	4.5%
5	1000	2.8%
6	924	2.6%
7	581	1.6%
8	504	1.4%
9	432	1.2%
10	330	0.9%

Value	Count	Frequency (%)
185	185	0.5%
157	157	0.4%
145	145	0.4%
142	284	0.8%
128	128	0.4%
85	85	0.2%
80	80	0.2%
77	77	0.2%
69	69	0.2%
57	57	0.2%

availability_365
Real number (ℝ)

ZEROS

Distinct	366
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	172.41891

Minimum	0
Maximum	365
Zeros	5475
Zeros (%)	15.2%
Negative	0
Negative (%)	0.0%
Memory size	281.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	43
median	160
Q3	316
95-th percentile	364
Maximum	365
Range	365
Interquartile range (IQR)	273

Descriptive statistics

Standard deviation	135.55391
Coefficient of variation (CV)	0.78618933
Kurtosis	-1.535679
Mean	172.41891
Median Absolute Deviation (MAD)	132
Skewness	0.12206185
Sum	6208460
Variance	18374.861
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	5475	15.2%
365	1553	4.3%
364	643	1.8%
269	498	1.4%
358	430	1.2%
1	404	1.1%
363	396	1.1%
362	341	0.9%
89	341	0.9%
360	330	0.9%
Other values (356)	25597	71.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	5475	15.2%
1	404	1.1%
2	90	0.2%
3	95	0.3%
4	85	0.2%
5	74	0.2%
6	92	0.3%
7	80	0.2%
8	72	0.2%
9	73	0.2%

Value	Count	Frequency (%)
365	1553	4.3%
364	643	1.8%
363	396	1.1%
362	341	0.9%
361	238	0.7%
360	330	0.9%
359	277	0.8%
358	430	1.2%
357	227	0.6%
356	231	0.6%

number_of_reviews_ltm
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	99
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.1173073

Minimum	0
Maximum	124
Zeros	14214
Zeros (%)	39.5%
Negative	0
Negative (%)	0.0%
Memory size	281.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	2
Q3	9
95-th percentile	32
Maximum	124
Range	124
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	11.662121
Coefficient of variation (CV)	1.638558
Kurtosis	8.0016977
Mean	7.1173073
Median Absolute Deviation (MAD)	2
Skewness	2.4872391
Sum	256280
Variance	136.00507
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	14214	39.5%
1	3431	9.5%
2	2400	6.7%
3	1721	4.8%
4	1282	3.6%
5	1074	3.0%
6	867	2.4%
7	765	2.1%
8	693	1.9%
9	654	1.8%
Other values (89)	8907	24.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	14214	39.5%
1	3431	9.5%
2	2400	6.7%
3	1721	4.8%
4	1282	3.6%
5	1074	3.0%
6	867	2.4%
7	765	2.1%
8	693	1.9%
9	654	1.8%

Value	Count	Frequency (%)
124	1	< 0.1%
120	1	< 0.1%
115	1	< 0.1%
113	1	< 0.1%
108	2	< 0.1%
105	2	< 0.1%
98	2	< 0.1%
96	2	< 0.1%
94	1	< 0.1%
93	2	< 0.1%

license
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	36008
Missing (%)	100.0%
Memory size	281.4 KiB

Auto

Heatmap
Table

	availability_365	calculated_host_listings_count	host_id	id	latitude	longitude	minimum_nights	number_of_reviews	number_of_reviews_ltm	price	reviews_per_month	room_type
availability_365	1.000	0.026	0.008	0.003	0.018	-0.126	-0.093	-0.202	-0.182	0.031	-0.187	0.076
calculated_host_listings_count	0.026	1.000	-0.143	0.105	-0.085	0.038	-0.077	0.054	0.078	0.107	0.061	0.082
host_id	0.008	-0.143	1.000	0.452	0.017	-0.076	-0.181	-0.164	-0.036	-0.117	0.157	0.053
id	0.003	0.105	0.452	1.000	-0.007	0.017	-0.224	-0.384	-0.111	-0.029	0.385	0.028
latitude	0.018	-0.085	0.017	-0.007	1.000	0.543	-0.058	-0.026	-0.025	-0.341	-0.037	0.110
longitude	-0.126	0.038	-0.076	0.017	0.543	1.000	0.091	0.136	0.141	-0.015	0.085	0.088
minimum_nights	-0.093	-0.077	-0.181	-0.224	-0.058	0.091	1.000	-0.040	-0.097	0.156	-0.192	0.000
number_of_reviews	-0.202	0.054	-0.164	-0.384	-0.026	0.136	-0.040	1.000	0.868	-0.070	0.594	0.041
number_of_reviews_ltm	-0.182	0.078	-0.036	-0.111	-0.025	0.141	-0.097	0.868	1.000	-0.046	0.804	0.067
price	0.031	0.107	-0.117	-0.029	-0.341	-0.015	0.156	-0.070	-0.046	1.000	0.013	0.013
reviews_per_month	-0.187	0.061	0.157	0.385	-0.037	0.085	-0.192	0.594	0.804	0.013	1.000	0.063
room_type	0.076	0.082	0.053	0.028	0.110	0.088	0.000	0.041	0.067	0.013	0.063	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	id	name	host_id	host_name	neighbourhood_group	neighbourhood	latitude	longitude	room_type	price	minimum_nights	number_of_reviews	last_review	reviews_per_month	calculated_host_listings_count	availability_365	number_of_reviews_ltm	license
0	17878	Condo in Rio de Janeiro · ★4.70 · 2 bedrooms · 2 beds · 1 bath	68997	Matthias	NaN	Copacabana	-22.96599	-43.17940	Entire home/apt	1357.0	5	311	2023-12-22	1.90	1	269	29	NaN
1	216461	Rental unit in Rio de Janeiro · 1 bedroom · 1 bed · 1 bath	1154263	Zeilma , Da	NaN	Flamengo	-22.93990	-43.17676	Private room	734.0	1	0	NaN	NaN	1	365	0	NaN
2	326205	Condo in Rio de Janeiro · ★4.57 · 1 bedroom · 1 bed · 1 bath	1603206	Bob	NaN	Copacabana	-22.96825	-43.18237	Entire home/apt	366.0	3	152	2023-11-21	1.07	5	293	14	NaN
3	25026	Rental unit in Rio de Janeiro · ★4.72 · 1 bedroom · 1 bed · 1 bath	102840	Viviane	NaN	Copacabana	-22.97735	-43.19105	Entire home/apt	865.0	2	275	2023-12-03	1.67	1	228	29	NaN
4	326575	Rental unit in Rio de Janeiro · ★4.81 · 2 bedrooms · 3 beds · 2 baths	1668565	Maria José	NaN	Copacabana	-22.97696	-43.18933	Entire home/apt	368.0	4	227	2023-11-21	1.58	1	245	12	NaN
5	216700	Rental unit in Rio de Janeiro · ★4.96 · 1 bedroom · 1 bed · 1 shared bath	1118486	Moara	NaN	Laranjeiras	-22.94373	-43.19147	Private room	300.0	3	24	2023-11-05	0.17	2	356	3	NaN
6	219250	Loft in Rio de Janeiro · ★4.82 · 1 bedroom · 2 beds · 1 bath	1134264	Ricardo	NaN	Santa Teresa	-22.91666	-43.17947	Entire home/apt	254.0	2	431	2023-12-11	3.07	2	312	25	NaN
7	35764	Loft in Rio de Janeiro · ★4.90 · 1 bedroom · 1 bed · 1.5 baths	153691	Patricia Miranda & Paulo	NaN	Copacabana	-22.98107	-43.19136	Entire home/apt	373.0	3	454	2023-12-17	2.82	1	62	36	NaN
8	220377	Rental unit in Rio de Janeiro · ★5.0 · 1 bedroom · 1 bed · 1 private bath	1142424	Taciana	NaN	Tijuca	-22.92880	-43.24046	Private room	220.0	1	4	2017-04-06	0.03	4	294	0	NaN
9	327375	Rental unit in Rio de Janeiro · ★4.0 · 6 bedrooms · 16 beds · 5 baths	1673501	Josy	NaN	Santa Teresa	-22.92129	-43.18193	Entire home/apt	5874.0	3	12	2020-02-25	0.09	1	365	0	NaN

	id	name	host_id	host_name	neighbourhood_group	neighbourhood	latitude	longitude	room_type	price	minimum_nights	number_of_reviews	last_review	reviews_per_month	calculated_host_listings_count	availability_365	number_of_reviews_ltm	license
35998	1053711355674934096	Rental unit in Rio de Janeiro · ★New · 1 bedroom · 1 bath	535697473	Victor	NaN	Copacabana	-22.967333	-43.181577	Entire home/apt	487.0	1	0	NaN	NaN	2	266	0	NaN
35999	1053716797020259779	Rental unit in Rio de Janeiro · ★New · 1 bedroom · 2 beds · 1 bath	154114238	Breno	NaN	Barra da Tijuca	-23.010436	-43.357412	Entire home/apt	889.0	2	2	2023-12-27	2.0	4	55	2	NaN
36000	1053720091301615651	Rental unit in Rio de Janeiro · ★New · 1 bedroom · 1 bath	55209037	Diogo	NaN	Camorim	-22.980449	-43.422670	Entire home/apt	229.0	1	0	NaN	NaN	1	267	0	NaN
36001	1053736263866696090	Rental unit in Rio de Janeiro · ★New · 1 bedroom · 2 beds · 1 bath	13411812	Fernando	NaN	Copacabana	-22.969913	-43.188015	Entire home/apt	760.0	2	0	NaN	NaN	16	87	0	NaN
36002	1053743193407023650	Rental unit in Rio de Janeiro · ★New · 1 bedroom · 2 beds · 1 bath	113031534	João	NaN	Barra da Tijuca	-23.003550	-43.340740	Entire home/apt	600.0	1	0	NaN	NaN	2	264	0	NaN
36003	1053746406056980189	Home in Rio de Janeiro · ★New · 1 bedroom · 4 beds · 1 bath	470173166	Marco	NaN	Botafogo	-22.956393	-43.182119	Private room	200.0	2	0	NaN	NaN	8	90	0	NaN
36004	1053756202332288557	Rental unit in Rio de Janeiro · ★New · 1 bedroom · 2 beds · 1 bath	6000862	Omar Do Rio	NaN	Copacabana	-22.980547	-43.195863	Entire home/apt	727.0	2	0	NaN	NaN	185	358	0	NaN
36005	1053789340172837654	Rental unit in Rio de Janeiro · ★New · 1 bedroom · 1 bed · 1 bath	206898000	Pablo	NaN	Copacabana	-22.968340	-43.185855	Private room	743.0	1	0	NaN	NaN	1	270	0	NaN
36006	1053808194231554793	Rental unit in Rio de Janeiro · ★New · 1 bedroom · 1 bath	536983374	Izaias	NaN	Vidigal	-22.996260	-43.240830	Entire home/apt	560.0	1	0	NaN	NaN	1	249	0	NaN
36007	1053823261878675052	Rental unit in Rio de Janeiro · ★New · 1 bedroom · 1 bed · 1 bath	694816	Samuel	NaN	Glória	-22.912241	-43.171288	Private room	175.0	2	0	NaN	NaN	1	19	0	NaN

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample